package com.trkj.dao.lzs;


import java.util.List;

import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;


import com.trkj.pojo.SocialSecurity;


public interface SocialSecurityDao  extends  CrudRepository<SocialSecurity, Long> {	

	 @Query("from SocialSecurity s where s.securityName like ?1")
	    public  List<SocialSecurity>queryByName(String text);	
	 
       @Query("SELECT s,p,w FROM SocialSecurity s left join s.socialAccount p  inner join s.socialLeixing w ")
     	public List<Object[]> find_pay();
 /*	*/
	 @Query("SELECT s,soc,w FROM SocialSecurity s inner join s.socialAccount soc inner join s.socialLeixing w ")
		public List<Object[]> find_social_table();

}	
